Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_BUFFERED_QUEUES

`DBA_HIST_BUFFERED_QUEUES` displays historical information about all buffered queues available for the instance.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SNAP_ID` | `NUMBER` | `NOT NULL` | Unique snapshot ID
`DBID` | `NUMBER` | `NOT NULL` | Database ID for the snapshot
`INSTANCE_NUMBER` | `NUMBER` | `NOT NULL` | Instance number for the snapshot
`QUEUE_SCHEMA` | `VARCHAR2(30)` | `NOT NULL` | Owner of the queue
`QUEUE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the queue
`STARTUP_TIME` | `DATE` | `NOT NULL` | Startup time of the instance
`QUEUE_ID` | `NUMBER` | `NOT NULL` | ID of the queue
`NUM_MSGS` | `NUMBER` |  | Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk)
`SPILL_MSGS` | `NUMBER` |  | Current number of overflow messages spilled to disk from the buffered queue
`CNUM_MSGS` | `NUMBER` |  | Cumulative total number of messages enqueued into the buffered queue since the buffered queue was created.
`CSPILL_MSGS` | `NUMBER` |  | Cumulative total number of overflow messages spilled to disk from the buffered queue since the buffered queue was created